using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using ViewStateEliminator.UI;

public partial class _Default : BaseNoViewStatePage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Database db = DatabaseFactory.CreateDatabase("Adventure");
            DbCommand cmd = db.GetSqlStringCommand("SELECT * FROM [AdventureWorksLT].[SalesLT].[vProductAndDescription]");
            this.GridView1.DataSource = db.ExecuteDataSet(cmd);
            this.GridView1.DataBind();
        }
    }
    protected void btnTest_Click(object sender, EventArgs e)
    {
        string retval = txtTest.Text + "----" + calTest.SelectedDate.ToLongDateString();
        this.lblDisplay.Text = retval;
    }
}
